PostgreSQL file Fdw

1、--添加扩展

CREATE EXTENSION file_fdw;

2、--创建SERVER FOR file

create server pg_file_server foreign data wrapper file_fdw;

3、创建外部表

create foreign table emp_file_fdw
 	(EMPNO int,
	ENAME varchar(10),
	JOB varchar(9),
	MGR int,
	HIREDATE DATE,
	SAL int,
	COMM int,
	DEPTNO int)
server pg_file_server 
options(filename '/home/postgres/emp.csv',format 'csv',header 'true',delimiter ','); 

4、如果是普通用户创建本地外部表，需要授权：

GRANT  pg_read_server_files to u1_fdw;
GRANT USAGE ON FOREIGN SERVER pg_file_server TO u1_fdw;